select NAME, rank, count, surname_entries.id 'wiki_id' from surnames left join surname_entries on surname_entries.surname = surnames.name and surname_entries.entry_type = 1 where index2 = 'BY' order by rank asc limit 0,100 Surnames > B > BY > BYA

Surnames > B > BY > BYA

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
BA BE BH BI BJ BL BO BR BS BU BY BZ
BY BYA BYB BYC BYD BYE BYF BYG BYH BYI BYK BYL BYM BYN BYO BYR BYS BYT BYU BYW BYX BYZ

Full Surname List Starting with BYA(Alphabetical)

BYAL
BYALL
BYAM
BYAN
BYARD
BYARS
BYAS
BYASSEE

Top 100 Surnames in the 2010 US Census starting with BYA

SurnameCountRankWiki?
BYARS 6683 5223 no
BYARD 1972 14986 yes
BYAS 1488 18540 no
BYAM 921 26492 no
BYASSEE 392 52851 no
BYALL 185 98099 no
BYAL 122 137327 no
BYAN 102 158432 no